package com.cskaoyan.mapper;

import com.cskaoyan.bean.Student;
import com.cskaoyan.bean.StudentVO;
import com.cskaoyan.bean.Teacher;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;
import java.util.Set;

/**
 * 创建日期: 2022/05/19 15:59
 *
 * @author ciggar
 */
public interface StudentMapper {

    // 一个简单参数
    String selectNameById(@Param("id") Integer id);


    // 多个简单参数
    List<String> selectAllNameList();


    // 单个对象
    Student selectStudentById(@Param("id") Integer id);

    // 单个对象
    StudentVO selectStudentVOById(@Param("id") Integer id);


    // 多个对象
    Student[] selectStudentList();


    // resultMap
    Student selectStudentByIdWithResultMap(@Param("id") Integer id);


    StudentVO selectStudentVOByIdWithResultMap(@Param("id") Integer id);


    List<Teacher> selectStudentListByName(@Param("name") String name);

}
